Shareware Grab Bag/Shareware Grab Bag.iso/006/javlrn2.arc/NUMBERS.CAS

Javelin Case Study | 1985-10-01 | 46.9 KB | 1,069 lines

NUMBERS
~0Copyright (c) 1985 Javelin Software Corporation.
S/N   0412345679
Press [F1] for Help.
Version E4.69
Diagram view
Table view
READY
$ $}$&ENTERING DATA AND FORMATTING NUMBERS}
$In this case study, we'll
$explore the different ways of
$entering data and
$formatting numbers in Javelin.
$- Press [Space] to continue -
$- or press [F1] for Help -
 228K
}$$There are a variety of ways to enter
~$values for a variable in Javelin. In
~"this case study you'll enter data:
 in the Chart view
 in the Table view
 in the Worksheet view
 with a Formula
~%This case study also describes how to
format numbers in Javelin.
Formatting a number affects how
~%Javelin displays that number, but not
the number itself.
You can format a number with a
~!percent sign (%), with commas, or
~%with a currency sign, such as $ or
~#You can also format a number with a
~"specific number of decimal places.
%EXAMPLE~
: The Coe Motor Company
You are an analyst for Coe, a
~"  small British motor company. Coe
~%  has been selling cars in the United
~%  Kingdom for the past few years, but
~!just introduced their car line to
~#  the American market in September.
~#  Based on the sales in the USA and
~#  the UK, it's your job to find the
  percentage of the Coe Motor
~!Company's sales in the US market.
 Start building the model by choosing the model
 settings for this problem.
 Use the Define Settings command:
 $ $ $
& $/' $D' $S'
 DEFINE }
  CLEAR
WINDOW   PRINT
MENU
~MDefine variable, building block, worksheet, graph, macro, time pd., settings.
 Settings
 Configuration
 Printer
 Time period
 Macro ...
 Graph
 Worksheet
 Building block
 Variable
 DEFINE
~@Create a variable or change its name, period, or other settings.
~KChange model default settings, including dates, default period, and format.
 FY1985 ends {31 Dec
 Year
 Quarter
 Month
 Week
 Yen (
 Pound (
 Constant
 Dollar ($)
"Default Period
 Commas
 Percent
 End date {September 1986}
 Fixed decimal
 Begin date {October 1985}
 Automatic
"Default Time Span
"Format
 Name {}
 Decimal places {}
"Model Settings
~7To save settings and leave settings sheet, press [Esc].
Begin by setting the time span.
~.Set the begin date to September 1985, when the
~ 1986 model cars are introduced:
'Sep85
Begin date:
~7To save settings and leave settings sheet, press [Esc].
"September 1985}
Set the end date to March 1986:
'Mar86
~    End date:
~7To save settings and leave settings sheet, press [Esc].
"March 1986}
~0Next, set the model format to Pound. This format
~2displays a pound sign (
) in front of all numbers.
$Press:
~-Look at the setting for decimal places, above
format.
~1When you choose a currency setting such as Pound,
~2you automatically set the number of decimal places
$to two.
~3Now that you have selected the default settings for
~3the model, press [Esc] to leave the settings sheet:
'[Esc]
Diagram view
Diagram view
READY
 An input variable is a variable
 for which you enter data.
 These are the input variables in
 this model:
 US Sales in Dollars
Table v~
 UK Sales in Pounds
 Pounds per Dollar
There are also two calculated
variables in this model:
 US Sales in Pounds, which
measures US sales in pounds.
% of sales in US, which is
the percentage of Coe's sales
  in the USA.
You're ready to begin defining
the variables for this model.
The first variable to define is
%UK Sales in Pounds~
~!This variable represents revenue,
~!in millions of pounds, from cars
sold in the UK each month.
&Entering Data in the Chart View
You can create a new variable
just by viewing it in the Chart
$or Table view.
~ o view a chart for the variable
UK Sales in Pounds, type:
& $/' $V' $C'
'UK Sales in Pounds
 DEFINE }
  CLEAR
WINDOW   PRINT
MENU
~MDefine variable, building block, worksheet, graph, macro, time pd., settings.
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
Show diagram in current window.
~$Show bar chart of data for variable.
Variable name:
READY
S O N D J F M A M J J A S O N D
100
120
UK Sales in Poun
$If you don't set an individual
format for a variable, the
variable uses the format and
number of decimals that you se
for the entire model.
~!UK Sales in Pounds will therefore
be displayed with a pound sign
and two decimal places.
Now enter the sales figures for
the first few months.
Sales were
73.93 million in
September, 1985. Enter:
'73.93
~ UK Sales in Pounds =
 Monthly d
73.93
To give the chart more detail,
show only one window on the
screen by typing:
& $/' $W' $1'
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
MENU
Select view for current window.
 Adjust
 Switch
 2 windows
 1 window
 WINDOW
Show only one window.
Diagram
READY
 30
UK Sales in Pounds =
 Monthly data: September 1985 - September...
73.93
te that you can see the value
for September in the upper left
~ corner of the screen, as well as
in the chart.
~ To enter sales for October, move
$the cursor to October:
~B UK Sales in Pounds =
 Monthly data: September 1985 - October...
Enter
77.35 million for sales:
'77.35
77.35
The time span at
top of the
~!Chart view shows you have entered
~ values for two months, September
and October, 1985.
~!Javelin updates this time span as
~"you enter values for other months.
values of UK Sales in Pounds
for the remaining months are:
   Nov
81.14 million
82.89 million
   Jan
83.97 million
   Feb
83.20 million
83.79 million
When you press [Space], I'
enter these values.
~;UK Sales in Pounds =
 Monthly data: September 1985 - Novem
81.14
82.89
~> UK Sales in Pounds =
 Monthly data: September 1985 - January
83.97
~:UK Sales in Pounds =
 Monthly data: September 1985 - Febr
March 1986
83.79
There are several benefits to
~ using the Chart view. With this
view you can:
 see the data in graphic form
at a glance
 see the actual value at any
period by moving the cursor
there
 quickly enter estimated data
~ The second variable to define is
%US Sales in Dollars~
. As its name
suggests, this variable is in
dollars, so it should have a
dollar format.
~!To set an individual format for a
~!variable, use the Define Variable
command. This command shows you
the Variable settings sheet for
the variable you specify.
o see the settings sheet for
, type:
     $ $
& $/' $D' $V'
  DEFINE   CLEAR
 WINDOW }
  PRINT
MENU
Set up or change windows.
 Settings
 Configuration
 Printer
 Time period
 Macro ...
 Graph
 Worksheet
 Building block
 Variable
 DEFINE
~KChange model default settings, including dates, default period, and format.
~@Create a variable or change its name, period, or other settings.
UK Sales in Pounds =
 Monthly data: September 1985 - March 1986
~#Variable name (UK Sales in Pounds):
Enter the variable name:
'US Sales in Dollars
 Default
 Unlo
 Guilder (fl)
 Deutsche Mark (DM)
 Swiss Franc (SFr)
 Franc (F)
 Yen (
 Pound (
 Year
 Dollar ($)
 Quar
 Commas
 Mont
 Percent
 Week
 Fixed decimal
 Day
 Automatic
 Cons
"Format
 Decimal places {}
 End date {}
 Begin date {}
 Name {US Sales in Dollars}
 "}    "Time Span
"Variable Settings
~7To save settings and leave settings sheet, press [Esc].
To display this variable with a
dollar format, change the
from the default model setting
~!(Pound, in this model) to Dollar.
Move to the dollar format:
Then select
%Dollar~
The values for US Sales in
~ Dollars are now formatted with a
dollar sign and two decimals.
To leave the settings sheet for
US Sales in Dollars, press:
'[Esc]
S O N D J F
A M J J A S O N D
   0
   5
  10
  15
  20
  25
  30
  35
  40
  45
  50
  55
  60
  65
  70
  75
  80
  85
  90
UK Sales in Pounds =
 Monthly data: September 1985 - March 1986
110
130
150
~#US Sales in Dollars =
 UNDEFINED
READY
&Entering Data in the Table View
After defining US Sales in
Dollars, you see the Chart view
for the variable.
~ Instead of using the Chart view,
$we'll enter in the values for
~ US Sales in Dollars in the Table
view.
$First, select the Table view:
     $ $
& $/' $V' $T'
 DEFINE }
  CLEAR
WINDOW   PRINT
MENU
~O  Define variable, building block, worksheet, graph, macro, time pd., settings.
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
~$Show bar chart of data for variable.
~"  Show table of data for variable.
US Sales in Dollars =
 UNDEFINED
~$Variable name (US Sales in Dollars):
~ Then use the SPELL key to select
US Sales in Dollars:
& $U'S' $}
WAIT
Sales in Dollars
MENU
READY
Apr 1987
  Dec 1988
Mar 1987
  Nov 1988
Feb 1987
  Oct 1988
Jan 1987
  Sep 1988
Dec 1986
  Aug 1988
Nov 1986
  Jul 1988
Oct 1986
  Jun 1988
Sep 1986
  May 1988
Aug 1986
  Apr 1988
Jul 1986
  Mar 1988
Jun 1986
  Feb 1988
May 1986
  Jan 1988
Apr 1986
  Dec 1987
Mar 1986
  Nov 1987
Feb 1986
  Oct 1987
Jan 1986
  Sep 1987
  May 1989
Dec 1985
  Aug 1987
  Apr 1989
Nov 1985
  Jul 1987
  Mar 1989
Oct 1985
  Jun 1987
  Feb 1989
Sep 1985
  May 1987
  Jan 1989
US Sales in Dollars =
 UNDEFINED
~ Coe's US sales for September and
October 1985 are:
$ Sep
$8 million
 $8.24 million
Enter these sales figures:
'8.24
~GUS Sales in Dollars =
 Monthly data: September 1985 - September 1985
.. $8.
~G US Sales in Dollars =
 Monthly data: September 1985 - October 1985
.. $8.24
~ Press [Space] and I'll enter the
~#remaining values for this variable.
November 1985
. $11.
. $13.92
13.92
January 1986
. $18.01
18.01
February 1986
. $24.
~D US Sales in Dollars =
 Monthly data: September 1985 - March 1986
. $28.
Suppose you entered an extra
~!value in the table by mistake, or
inadvertently omitted the data
for a month.
Instead of retyping the entire
table from the mistake on, you
can easily correct these errors
}    $with the }
%[Ins]~
%[Del]~
 keys.
(The [Ins] and [Del] keys are
below the
 key, at the lower
ight of the keyboard.)
Let's say the value entered for
December, $13.92 million,
~ shouldn't have been on the list.
~!The actual value for December was
then entered for January, and a
subsequent values were entered
for the wrong months.
Instead of retyping the table
from the mistake on, use the
[Del] key to correct the error.
~!Move the cursor to the month with
the unwanted value:
Press the [Del] key to delete
the value for December:
'[Del]
~FUS Sales in Dollars =
 Monthly data: September 1985 - February 1986
The value 13.92 disappears, and
all subsequent values shift up
one month.
$Similarly, if you omit a value
from the table, you can insert
~!the value by using the [Ins] key.
To insert a value for December,
$press [Ins]:
'[Ins]
. $28.
~D US Sales in Dollars =
 Monthly data: September 1985 - March 1986
The January value of 18.01 is
inserted for December, and a
~ subsequent values shift down one
month.
~!Type the correct number in place
of the error for December:
'13.92
13.92
values for US Sales in Dollars
are correct again.
~ The sales figures for April just
came in. Coe's revenues from
sales in the USA in April are
$37.06 million.
$Let's add the April value for
US Sales in Dollars.
~"Move the cursor to the row of the
table for April 1986:
'[End]
~ Now type in the value for April,
$37.06 million:
'37.06
April
. $37.06
37.06
You now have data for two
variables:
 UK Sales in Pounds
 US Sales in Dollars
The first variable is in pounds
and the second is in dollars.
}!$Before you can compare the values
~!of these variables, however, they
must be in the same currency.
 $ $}
&Entering Data with a Formula
We need a formula that converts
~!dollars into pounds at a constant
rate. (For this case study,
~ assume that there are .77 pounds
to the dollar.)
There is a third way to enter
data -- with a formula.
} $Let's define the conversion rate
with a variable named
%Pounds per
%Dollar~
. We'll give this variable
a fixed value of .77 pounds per
dollar.
To define Pounds per Dollar and
~ give it a constant value of .77,
enter the following formula:
'Pounds per Dollar=.
7'7' $}
WAIT
READY
~    CONSTANT
Pounds per Dollar=0.77
~ The Table view shows that Pounds
per Dollar is a constant.
} $To format Pounds per Dollar with
decimal format, type:
& $/' $D' $V' $}
  DEFINE   CLEAR
VIEW
WINDOW   PRINT
MENU
Select view for current window.
 Settings
 Configuration
 Printer
 Time period
 Macro ...
 Graph
 Worksheet
 Building block
 Variable
 DEFINE
~@Create a variable or change its name, period, or other settings.
CONSTANT
Pounds per Dollar=0.77
~"Variable name (Pounds per Dollar):
 Default
 Unlo
 Guilder (fl)
 Deutsche Mark (DM)
 Swiss Franc (SFr)
 Franc (F)
 Yen (
 Pound (
 Year
 Dollar ($)
 Quar
 Commas
 Mont
 Percent
 Week
 Fixed decimal
 Day
 Automatic
 Cons
"Format
 Decimal places {}
 End date {}
 Begin date {}
 Name {Pounds per Dollar}
 "}    "Time Span
"Variable Settings
~7To save settings and leave settings sheet, press [Esc].
~!Press [Esc] to leave the settings
sheet for the variable:
'[Esc]
TANT
0.77
Pounds per Dollar=0.77
READY
Now that the conversion rate is
~ part of the model, you can enter
~ a formula that converts US Sales
from dollars to pounds.
$Press [Space] and I'll enter a
}!$formula that defines the variable
%US Sales in Pounds~
NOT YET CALCULATED
~8US Sales in Pounds=US Sales in Dollars*Pounds per Dollar
~!Calculate the values for US Sales
in Pounds:
'[F9]
WAIT
~    Apr 1987
  Dec 1988
~    Mar 1987
  Nov 1988
~    Feb 1987
  Oct 1988
~    Jan 1987
  Sep 1988
~    Dec 1986
  Aug 1988
~    Nov 1986
  Jul 1988
~    Oct 1986
  Jun 1988
~    Sep 1986
  May 1988
~    Aug 1986
  Apr 1988
~    Jul 1986
  Mar 1988
~    Jun 1986
  Feb 1988
~    May 1986
  Jan 1988
~    Apr 1986
28.54
  Dec 1987
~    Mar 1986
22.07
  Nov 1987
    ~    Feb 1986
18.56
  Oct 1987
~    Jan 1986
13.87
  Sep 1987
  May 1989
~    Dec 1985
10.72
  Aug 1987
  Apr 1989
~    Nov 1985
  Jul 1987
  Mar 1989
~    Oct 1985
  Jun 1987
  Feb 1989
~    Sep 1985
  May 1987
  Jan 1989
READY
The default format (
appropriate for this variable,
so there's no need to set an
individual format.
So far you have entered numbers
three ways:
 in the Chart view
 in the Table view
 with a formula
  Jun 1989
  Jul 1989
  Aug 1989
  Sep 1989
  Oct 1989
  Nov 1989
 $}#&Entering Data in the Worksheet View
 The final way to enter numbers in a model is on a
 worksheet. Let's create a worksheet for showing the
 values of the variables in this case study. Type:
 $ $ $
& $/' $V' $W'
 DEFINE }
  CLEAR
WINDOW   PRINT
MENU
~O  Define variable, building block, worksheet, graph, macro, time pd., settings.
 Graph
 Macro
 Errors
 Notes
 Worksheet
 Quick graph
 Chart
 Table
 Formulas ...
 Diagram
 VIEW
~ Show table of data for variable.
~#Show a worksheet in current window.
  Mar 19
  Feb 19
  Jan 19
28.54
  Dec 19
22.07
  Nov 19
18.56
  Oct 19
13.87
  Sep 19
10.72
  Aug 19
  Jul 19
  Jun 19
6.16
  May 19
US Sales in Pounds=US Sales in Dollars*Pounds per Dollar
Worksheet name:
~3Javelin now prompts you for a worksheet name at the
~4top of the screen. You can give a worksheet any name
~    you like.
~*Press [Space] and I'll name the worksheet.
WAIT
READY
SALES (in millions of pounds)
~/Press [Space] again and I'll enter the names of
~.variables in the left border of the worksheet.
WAIT
Pounds per Dollar
READY
Pounds per Dollar
Pounds per Dollar
US Sales in Pounds
US Sales in Pounds
WAIT
Sales in Pounds
READY
UK Sales in Pounds
UK Sales in Pounds
~2Now we only need to add the dates to the worksheet
in order to see the data.
~3Enter September 1985 for the first month to show on
the worksheet. Type:
'Sep85
73.93
Sep 1985
~0tice that Javelin fills in the values for Sep 85
~-as soon as you enter the month in the border.
~1This is because you entered these values earlier
~1y are part of Javelin's central information base.
~0Pressing
 automatically enters the next month
in the top border.
~3Add the next six months by pressing
 six times:
77.35
Oct 1985
81.14
Nov 1985
82.89
10.72
Dec 1985
83.97
13.87
Jan 1986
83.20
18.56
Feb 1986
81.14
82.89
83.97
10.72
13.87
18.56
6  Feb
83.79
22.07
Mar 1986
81.14
82.89
83.97
10.72
13.87
18.56
22.07
6  Feb
~2The original problem was to find the percentage of
Coe's sales in the USA.
~,To find the solution, create a new variable,
%% of Sales in US~
. We'll define this variable in
}4$a formula that divides US Sales in Pounds by the sum
~-of UK Sales in Pounds and US Sales in Pounds.
~,When you're on a worksheet, you can define a
~0variable just by typing its name in a border and
~3then entering a value or a formula for the variable
in the body of the worksheet.
~2Press [Space] and I'll move the cursor back to the
left border.
5  Dec
5  Jan
Feb 1986
10.72
18.56
73.93
77.35
81.14
82.89
83.20
Pounds per Dollar
US Sales in Pounds
~#Enter the name of the new variable,
%% of Sales in US~
in the left border:
'% of Sales in US
% of Sales in US
% of Sales in US:
~/The expression that defines % of Sales in US is
~(US Sales in Pounds/(UK Sales in Pounds +
US Sales in Pounds)
~1Let's use Javelin's pointing feature to write the
expression.
Press the POINT key, [F4]:
'[F4]
% of Sales in US:
POINT
% of Sales in US
~1Then point to the formula for US Sales in Pounds:
UK Sales in Pounds
US Sales in Pounds
~3Notice that Javelin copies the variable to the edit
~*line when you point to it with the cursor.
~1We'll divide US Sales in Pounds by the sum of two
~!variables, so type the following:
& $/' $('
~,Point to the formula for UK Sales in Pounds:
UK Sales in Pounds
~.And add US Sales in Pounds to the denominator:
& $+' $
US Sales in Pounds
~,Finally, close the parentheses and enter the
expression:
& $)' $}
READY
#CALC
#CALC
#CALC
#CALC
#CALC
#CALC
~L% of Sales in US: US Sales in Pounds/(UK Sales in Pounds+US Sales in Pounds)
~3Now let's calculate the model to see the values for
% of Sales in US:
'[F9]
WAIT
READY
~3The values for % of Sales in US would be easier to
~$read if they were in percent format.
}2$In addition to formatting the model and individual
~4variables, you can also format areas of a worksheet.
You can format:
 $~-
 an entire worksheet
 a worksheet column
 a worksheet row
 a worksheet ce
~1A worksheet format affects the display of numbers
~&only on the worksheet where it is set.
~4To format the row containing % of Sales in US with a
~3percent sign and one decimal, first move the cursor
to the left border:
~$Next, use the *Format command. Type:
     $ $
& $/' $*' $F'
  DEFINE   CLEAR
WINDOW   PRINT
 *WORKSHEET
MENU
~"Commands specific to current view.
 Format
 Sort ...
 Exception
 Name change
 Import file ..
 Range ...
 Border ...
 Data copy
 Copy
 *WORKSHEET
~"  Change width of current column.
View or change formats.
83.97
13.87
-85  Jan 1986  Feb
SALES (in millions of pounds)
READY
 Yen (
 Pound (
 Dollar ($)
 Commas
 Percent
 Fixed decimal
 Automatic
"Format
 Decimal places {}
"Format Settings
~7To save settings and leave settings sheet, press [Esc].
~)Enter 1 for the number of decimal places:
& $1' $}
Decimal places:
~7To save settings and leave settings sheet, press [Esc].
~%Choose Percent for the format. Press:
~.Finally, leave the settings sheet by pressing:
'[Esc]
73.93
77.35
81.14
82.89
10.72
   0.77
}%-ep 1985  Oct 1985  Nov 1985  Dec 1985
SALES (in millions of pounds)
  7.7%
  7.6%
 10.1%
 11.5%
 14.2%
 18.2%
% of Sales in US
~4The % format is attached to that specific row of the
~#worksheet, and not to the variable.
~1By looking at the values of % of Sales in US, you
~1can see that the Coe Motor Company started out by
~3selling 7.7% of their cars in the USA in September.
~!o see the values for March, type:
'[End]
~)End: Press arrow key to select direction.
WAIT
6  Feb
10.72
13.87
18.56
22.07
81.14
82.89
83.97
READY
% of Sales in US
~<: US Sales in Pounds/(UK Sales in Pounds+US Sales in Pounds)
~3By March 1986, Coe's percentage of sales in the USA
increased to 20.8%.
~4We still need to add the April value for UK Sales in
$Pounds.
~3Let's complete the sales figures for April 1986 on
this worksheet.
~2Move to the right of March 1986 in the top border:
'[End]
81.14
82.89
83.97
10.72
13.87
18.56
22.07
6  Feb
~)End: Press arrow key to select direction.
WAIT
READY
~/To add the next month (April 1986), just press:
28.54
Apr 1986
83.97
10.72
13.87
18.56
22.07
28.54
6  Feb
~1Pounds per Dollar has a constant value of .77, so
}1$it's shown in the column for April automatically.
~/April's value for US Sales in Pounds is already
~2calculated, so it is also displayed automatically.
~3To enter the value for UK Sales in Pounds for April
~4on the worksheet, move the cursor to the cell at the
~0ntersection of April 1986 and UK Sales in Pounds
and enter 85.48:
'85.48
Apr 1986
Pounds per Dollar: 0.
~9US Sales in Pounds: US Sales in Dollars*Pounds per Dollar
 @ April 1986:
~ UK Sales in Pounds @ April 1986:
85.48
~&UK Sales in Pounds @ April 1986: 85.48
~)Now calculate % of Sales in US for April:
'[F9]
WAIT
25.0%
READY
~3The worksheet shows April's value for % of Sales in
~2US. The Coe Motor Company's US sales jumped to 25%
in April, 1986.
&Summary
 In this case study:
 You entered numbers in the Chart view
   and the Table view, and with a formula.
 You formatted these numbers as needed.
 You then created}
$ a worksheet that showed
~(the model's variables, and formatted the
  numbers on the worksheet.
a formula on the worksheet
~)that calculated the % of Sales in the US.
~*Finally, you entered another month's sales
~"figures directly on the worksheet.
Related case studies:
%The Javelin Worksheet~
 shows you some ways
~ to use Javelin's Worksheet view.
}#%Importing Data into a Javelin Model~
 covers
~.three ways to import information into a model.
%Graphing with Javelin~
 introduces you to
using Javelin's graphs.